Convert Excel to HTML

VB C#

from ironxl import *

# Load the Excel workbook
workbook = WorkBook.Load("sample.xlsx")

# Set up HTML export options
options = HtmlExportOptions()
options.OutputRowNumbers = True
options.OutputColumnHeaders = True
options.OutputHiddenRows = True
options.OutputHiddenColumns = True
options.OutputLeadingSpacesAsNonBreaking = True

# Export workbook to HTML file
workbook.ExportToHtml("workBook.html", options)

Convert Excel to HTML

The code example above demonstrates how to convert an Excel file to HTML using IronXL for Python. The HtmlExportOptions class is used to customize the HTML output. The available options are:

OutputRowNumbers property: Controls whether row numbers are included in the resulting HTML file.
OutputColumnHeaders property: Controls whether column headers are included in the resulting HTML file.
OutputHiddenRows property: Controls whether hidden rows are displayed in the resulting HTML file.
OutputHiddenColumns property: Controls whether hidden columns are displayed in the resulting HTML file.
OutputLeadingSpacesAsNonBreaking property: Controls whether leading spaces in cells are rendered as non-breaking spaces in the resulting HTML file.

Discover more Excel file type conversions with IronXL for Python.